package migracion;
import java.util.Map;
import java.util.HashMap;
import java.io.File;
import java.io.FileInputStream;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 * @author JFM
 */
public class Test
	{
	public static void main(String args[]) throws Exception
		{
		Sheet hoja;
		HSSFWorkbook workbook;
		FileInputStream excel;
		
		excel = new FileInputStream(new File("Migracion_Ordenes_Trabajo.xls"));
		workbook = new HSSFWorkbook(excel);
		hoja = workbook.getSheetAt(0);

		for(int i=1,n=hoja.getLastRowNum(); i<=n; i++)
			{
			Row fila = hoja.getRow(i);
			String logotipo = fila.getCell(2).getStringCellValue();
			if(logotipo != null && logotipo.length() > 0)
				{
				logotipo = logotipo.toLowerCase();
				logotipo = logotipo.substring(0, 1).toUpperCase() + logotipo.substring(1);
				System.out.println(logotipo);
				}
			}
		}
	}
